-
Index/Match with two criteria: MATCH must use Search Type 1
Like the title says, I need to match on TWO criteria in an INDEX/MATCH function. The two lookup criteria are: 1) Phase (this one is straightforward) 2) largest value less than or equal to a given per…1 · -
Re: How to have a Date and Time format for Date Column Properties?
You don't even need the API to expose it - you can expose it RIGHT in the sheet itself with =[Due Date]@row + "" The problem is that there is no ability to SET the TIME in either the Start …4 ·